package com.atguigu.tingshu.album.service.impl;

import com.alibaba.fastjson.JSONObject;
import com.atguigu.tingshu.album.mapper.*;
import com.atguigu.tingshu.album.service.BaseCategoryService;
import com.atguigu.tingshu.model.album.*;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import io.swagger.v3.core.util.Json;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

@Service
@SuppressWarnings({"all"})
public class BaseCategoryServiceImpl extends ServiceImpl<BaseCategory1Mapper, BaseCategory1> implements BaseCategoryService {

	@Autowired
	private BaseCategory1Mapper baseCategory1Mapper;

	@Autowired
	private BaseCategory2Mapper baseCategory2Mapper;

	@Autowired
	private BaseCategory3Mapper baseCategory3Mapper;


	@Autowired
	private BaseCategoryViewMapper baseCategoryViewMapper;

	@Autowired
	private BaseAttributeMapper baseAttributeMapper;


	@Override
	public List<BaseCategory3> findTopBaseCategory3(Long category1Id) {
		//	select * from base_category3 where category2_id in (101,102,103) and is_top = 1 limit 7
		//	根据一级分类Id 查询二级分类数据Id
		List<BaseCategory2> category2List = baseCategory2Mapper.selectList(new LambdaQueryWrapper<BaseCategory2>().eq(BaseCategory2::getCategory1Id, category1Id));
		//	101,102,103
		List<Long> category2IdList = category2List.stream().map(BaseCategory2::getId).collect(Collectors.toList());
		LambdaQueryWrapper<BaseCategory3> wrapper = new LambdaQueryWrapper<>();
		wrapper.eq(BaseCategory3::getIsTop,1).in(BaseCategory3::getCategory2Id,category2IdList).last(" limit 7 ");
		return baseCategory3Mapper.selectList(wrapper);
	}

	@Override
	public JSONObject getBaseCategoryList(Long category1Id) {
		//	声明一个对象
		JSONObject category1 = new JSONObject();
		//	categoryId categoryName categoryChild
		category1.put("categoryId",category1Id);
		//	base_category1  base_category_view
		List<BaseCategoryView> categoryViewList = baseCategoryViewMapper.selectList(new LambdaQueryWrapper<BaseCategoryView>().eq(BaseCategoryView::getCategory1Id, category1Id));
		category1.put("categoryName",categoryViewList.get(0).getCategory1Name());
		//	查询二级分类数据集合：以二级分类Id作为分组条件  key = category2Id; value=List<BaseCategoryView>
		Map<Long, List<BaseCategoryView>> map = categoryViewList.stream().collect(Collectors.groupingBy(BaseCategoryView::getCategory2Id));
		//	声明一个存储二级分类的集合对象
		ArrayList<JSONObject> categoryChild2List = new ArrayList<>();
		//	循环遍历map 集合
		Iterator<Map.Entry<Long, List<BaseCategoryView>>> iterator = map.entrySet().iterator();

		while (iterator.hasNext()){
			Map.Entry<Long, List<BaseCategoryView>> entry = iterator.next();
			//	获取key
			Long category2Id = entry.getKey();
			List<BaseCategoryView> category2list = entry.getValue();
			//	创建二级分类对象
			JSONObject category2 = new JSONObject();
			category2.put("categoryId",category2Id);
			category2.put("categoryName",category2list.get(0).getCategory2Name());
			//	创建三级分类集合
			List<JSONObject> category3List = category2list.stream().map(baseCategoryView -> {
				//	创建一个三级分类对象
				JSONObject category3 = new JSONObject();
				category3.put("categoryId", baseCategoryView.getCategory3Id());
				category3.put("categoryName", baseCategoryView.getCategory3Name());
				return category3;
			}).collect(Collectors.toList());
			category2.put("categoryChild",category3List);
			//	将二级分类对象添加到集合中.
			categoryChild2List.add(category2);
		}
		//	一级分类数据下的二级分类集合
		category1.put("categoryChild",categoryChild2List);
		//	返回数据
		return category1;
	}

	@Override
	public BaseCategoryView getCategoryView(Long category3Id) {
		//	调用mapper
		return baseCategoryViewMapper.selectById(category3Id);
	}

	@Override
	public List<BaseAttribute> findAttributeByCategory1Id(Long category1Id) {
		//	调用mapper层方法
		return baseAttributeMapper.selectBaseAttributeList(category1Id);
	}

	@Override
	public List<JSONObject> getBaseCategoryList() {
		//	创建集合对象
		List<JSONObject> list = new ArrayList<>();
		//	查看所有分类数据
		List<BaseCategoryView> baseCategoryViewList = baseCategoryViewMapper.selectList(null);
		//	按照一级分类Id 进行分组 key:一级分类Id， value:一级分类Id 对应的集合数据
		Map<Long, List<BaseCategoryView>> map = baseCategoryViewList.stream().collect(Collectors.groupingBy(BaseCategoryView::getCategory1Id));
		//	循环遍历数据
		for (Map.Entry<Long, List<BaseCategoryView>> entry : map.entrySet()) {
			//	获取到一级分类Id
			Long category1Id = entry.getKey();
			//	获取到一级分类Id 对应的集合数据
			List<BaseCategoryView> category1ViewList = entry.getValue();
			// 声明一级分类对象
			JSONObject category1 = new JSONObject();
			category1.put("categoryId", category1Id);
			category1.put("categoryName", category1ViewList.get(0).getCategory1Name());

			//	按照二级分类Id 进行分组
			Map<Long, List<BaseCategoryView>> map2 = category1ViewList.stream().collect(Collectors.groupingBy(BaseCategoryView::getCategory2Id));
			// 声明二级分类对象集合
			List<JSONObject> category2Child = new ArrayList<>();
			//	循环遍历
			for (Map.Entry<Long, List<BaseCategoryView>> entry2 : map2.entrySet()) {
				//	获取到二级分类Id
				Long category2Id = entry2.getKey();
				//	获取到二级分类Id 对应的集合数据
				List<BaseCategoryView> category2ViewList = entry2.getValue();
				//	创建二级分类对象
				JSONObject category2 = new JSONObject();
				category2.put("categoryId",category2Id);
				category2.put("categoryName",category2ViewList.get(0).getCategory2Name());

				// 循环三级分类数据
				List<JSONObject> category3Child = category2ViewList.stream().map(baseCategoryView -> {
					JSONObject category3 = new JSONObject();
					category3.put("categoryId", baseCategoryView.getCategory3Id());
					category3.put("categoryName", baseCategoryView.getCategory3Name());
					return category3;
				}).collect(Collectors.toList());
				// 将三级数据放入二级里面
				category2.put("categoryChild", category3Child);
				//	将二级分类对象添加到集合中
				category2Child.add(category2);
			}
			// 将三级数据放入二级里面
			category1.put("categoryChild", category2Child);
			//	将一级分类数据放入到集合中。
			list.add(category1);
		}
		return list;
	}
}
